Hej! Jag håller på och gör ett spel som heter Sandwich Fun. Här är min kod, men jag får ett felmeddelande:
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'circlesun'@'10.31.15.11' (using password: YES) in /data/d/f/df1b9f26-212d-47f0-b054-b325883c1648/sandwich-fun.com/web/db.php:8 Stack trace: #0 /data/d/f/df1b9f26-212d-47f0-b054-b325883c1648/sandwich-fun.com/web/db.php(8): mysqli_connect('mariadb105.r101...', 'circlesun', 'Canopus88!', 'alacrity') #1 /data/d/f/df1b9f26-212d-47f0-b054-b325883c1648/sandwich-fun.com/web/index.php(1): require('/data/d/f/df1b9...') #2 {main} thrown in /data/d/f/df1b9f26-212d-47f0-b054-b325883c1648/sandwich-fun.com/web/db.php on line 8
Här är min kod:
Kod:
<?php
$servername = "mariadb105.r101.websupport.se";
$username = "circlesun";
$password = "Canopus88!";
$db = "alacrity";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $db);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>
Och:
Kod:
<?php require 'db.php'; ?>
<?php $sql = "SELECT * FROM users WHERE keyword like '%".$_GET['search']."'";
echo $sql;
$result = mysql_query($sql)or die(mysql_error()); ?>
<!DOCTYPE html>
<html>
<head>
<title>Sandwich Fun - Free MMORPG!</title>
<meta charset="UTF-8">
</head>
<body>
<input type="text" name="search" method="GET">
<input type="submit" value="Send Request" action="register-account.php">
</body></html>